﻿using System;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using BusinessEntity;

namespace BusinessService
{
   public class SheetHistoryService
    {
       public int AddOne(SheetHistory model)
       {
           var sql = "insert into SheetHistory values(@sheetid,@opid,@operid,@opdate,@remark)";
           return SqlHelper.ExecuteNonQuery(sql, 
               new SqlParameter("@sheetid",model.SheetId),
               new SqlParameter("@opid",model.OpId),
               new SqlParameter("@operid",model.OperId),
               new SqlParameter("@opdate", model.OpDate),
               new SqlParameter("@remark", model.Remark)
               );
       }
    }
}
